InventoryState

Entity Definition

Logical Name : InventoryState
Physical Name : CO_ST_INV

A state that StockItems are kept in the retail enterprise item inventory records. Suggested values include: OnHand, OnOrder, OnLayaway, Damaged, ToBeReturned etc....

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemInventoryStateID (PK) A unique retailer assigned identifier for ItemInventoryStates. ID_ST_INV Identity integer
InventoryStateName The common name for ItemInventoryStates. NM_ST_INV Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
InventoryState defines condition of InventoryFact
InventoryState defines ItemInventory
InventoryState is permitted via InventoryStatePermissions

Logical Views containing InventoryState

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02316 - Distributed Order Management View
Logical 03300 - Reporting - Stock Ledger View